﻿if exists (select * from dbo.sysobjects where name = 'sp_tblDiscount_GetById')
	drop procedure [dbo].[sp_tblDiscount_GetById]
Go 
CREATE PROCEDURE dbo.sp_tblDiscount_GetById
@_did	int
AS
SELECT * FROM tblDiscount WHERE  _did= @_did
Go